PREVIEW / etf_30min / 2010-06-25

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-25.parquet
  size:    251 KB
  rows:    8,259

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2010-06-25 04:00:00	SPY	ETF	107.72	107.72	107.53	107.53	1309.0
2010-06-25 04:30:00	SPY	ETF	107.48	107.48	107.39	107.39	300.0
2010-06-25 05:30:00	SPY	ETF	107.37	107.37	107.07	107.07	4800.0
2010-06-25 06:00:00	SPY	ETF	107.24	107.34	107.22	107.29	3460.0
2010-06-25 06:30:00	SPY	ETF	107.36	107.59	107.36	107.59	18100.0
2010-06-25 07:00:00	SPY	ETF	107.57	107.75	107.49	107.74	278962.0
2010-06-25 07:30:00	SPY	ETF	107.75	107.99	107.74	107.92	511070.0
2010-06-25 08:00:00	SPY	ETF	107.9	107.93	107.62	107.67	798082.0
2010-06-25 08:30:00	SPY	ETF	107.68	107.7	107.22	107.47	2291794.0
2010-06-25 09:00:00	SPY	ETF	107.47	107.76	107.43	107.74	1776599.0
2010-06-25 09:30:00	SPY	ETF	107.74	107.75	107.08	107.5	26399751.0
2010-06-25 10:00:00	SPY	ETF	107.48	107.83	107.19	107.36	17604842.0
2010-06-25 10:30:00	SPY	ETF	107.36	107.79	106.77	106.89	19978387.0
2010-06-25 11:00:00	SPY	ETF	106.89	107.3	106.88	107.24	11801450.0
2010-06-25 11:30:00	SPY	ETF	107.25	107.55	107.0	107.37	12049262.0
2010-06-25 12:00:00	SPY	ETF	107.37	107.63	107.26	107.56	13651013.0
2010-06-25 12:30:00	SPY	ETF	107.57	107.73	107.32	107.445	9140123.0
2010-06-25 13:00:00	SPY	ETF	107.44	108.12	107.39	108.12	14697355.0
2010-06-25 13:30:00	SPY	ETF	108.12	108.42	108.02	108.23	12081865.0
2010-06-25 14:00:00	SPY	ETF	108.22	108.38	108.01	108.25	10252254.0
2010-06-25 14:30:00	SPY	ETF	108.25	108.38	108.02	108.15	6582815.0
2010-06-25 15:00:00	SPY	ETF	108.1524	108.16	107.69	107.84	13277782.0
2010-06-25 15:30:00	SPY	ETF	107.84	108.24	107.55	107.89	37223648.0
2010-06-25 16:00:00	SPY	ETF	107.89	108.27	106.99	107.94	17649540.0
2010-06-25 16:30:00	SPY	ETF	107.94	108.06	107.82	108.0	5545221.0
2010-06-25 17:00:00	SPY	ETF	108.0	108.02	107.8	107.85	402269.0
2010-06-25 17:30:00	SPY	ETF	107.85	107.97	107.84	107.89	157844.0
2010-06-25 18:00:00	SPY	ETF	107.87	107.95	107.42	107.65	833907.0
2010-06-25 18:30:00	SPY	ETF	107.65	107.66	107.61	107.64	33001.0
2010-06-25 19:00:00	SPY	ETF	107.65	107.71	107.62	107.67	106468.0
2010-06-25 19:30:00	SPY	ETF	107.7	107.75	107.65	107.72	40879.0
2010-06-25 04:00:00	QQQ	ETF	45.47	45.49	45.46	45.47	15414.0
2010-06-25 04:30:00	QQQ	ETF	45.33	45.36	45.3	45.36	13100.0
2010-06-25 05:00:00	QQQ	ETF	45.3	45.3	45.3	45.3	20000.0
2010-06-25 05:30:00	QQQ	ETF	45.3	45.3	45.3	45.3	400.0
2010-06-25 06:30:00	QQQ	ETF	45.35	45.4	45.35	45.39	1900.0
2010-06-25 07:00:00	QQQ	ETF	45.44	45.5	45.38	45.5	38099.0
2010-06-25 07:30:00	QQQ	ETF	45.54	45.59	45.52	45.54	30113.0
2010-06-25 08:00:00	QQQ	ETF	45.56	45.56	45.48	45.48	126760.0
2010-06-25 08:30:00	QQQ	ETF	45.48	45.53	45.06	45.44	1787959.0
2010-06-25 09:00:00	QQQ	ETF	45.44	45.56	45.42	45.52	408692.0
2010-06-25 09:30:00	QQQ	ETF	45.51	45.51	45.05	45.26	11072251.0
2010-06-25 10:00:00	QQQ	ETF	45.26	45.44	45.12	45.21	8015068.0
2010-06-25 10:30:00	QQQ	ETF	45.215	45.24	44.95	45.0	6592180.0
2010-06-25 11:00:00	QQQ	ETF	45.005	45.21	44.99	45.17	4110970.0
2010-06-25 11:30:00	QQQ	ETF	45.17	45.26	45.06	45.1901	3779088.0
2010-06-25 12:00:00	QQQ	ETF	45.19	45.36	45.14	45.33	3162399.0
2010-06-25 12:30:00	QQQ	ETF	45.33	45.4	45.2	45.26	3925716.0
2010-06-25 13:00:00	QQQ	ETF	45.26	45.53	45.24	45.53	7221481.0
2010-06-25 13:30:00	QQQ	ETF	45.53	45.66	45.48	45.5572	4621251.0

> showing 50 of 8,259 rows — these rows as CSV

> unlock the full archive -- $79 one-time