PREVIEW / etf_30min / 2010-10-28

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-28.parquet
  size:    255 KB
  rows:    8,545

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-10-28 04:30:00	SPY	ETF	118.55	118.59	118.55	118.59	250.0
2010-10-28 05:00:00	SPY	ETF	118.72	118.72	118.67	118.72	3250.0
2010-10-28 05:30:00	SPY	ETF	118.7	118.71	118.69	118.71	2500.0
2010-10-28 06:00:00	SPY	ETF	118.62	118.65	118.62	118.65	15000.0
2010-10-28 06:30:00	SPY	ETF	118.59	118.6	118.55	118.55	20600.0
2010-10-28 07:00:00	SPY	ETF	118.57	118.57	118.5	118.56	16025.0
2010-10-28 07:30:00	SPY	ETF	118.54	118.58	118.44	118.56	143194.0
2010-10-28 08:00:00	SPY	ETF	118.52	118.93	118.22	118.92	1048045.0
2010-10-28 08:30:00	SPY	ETF	118.94	119.2	118.86	119.0	3441185.0
2010-10-28 09:00:00	SPY	ETF	119.0	119.09	118.62	119.06	867023.0
2010-10-28 09:30:00	SPY	ETF	119.06	119.11	118.72	118.815	16028246.0
2010-10-28 10:00:00	SPY	ETF	118.81	118.94	118.17	118.24	18545727.0
2010-10-28 10:30:00	SPY	ETF	118.24	118.32	118.03	118.25	15417179.0
2010-10-28 11:00:00	SPY	ETF	118.26	118.51	118.21	118.46	8764075.0
2010-10-28 11:30:00	SPY	ETF	118.45	118.47	118.12	118.15	5888266.0
2010-10-28 12:00:00	SPY	ETF	118.14	118.14	117.89	117.92	11391334.0
2010-10-28 12:30:00	SPY	ETF	117.91	118.06	117.83	117.91	6016487.0
2010-10-28 13:00:00	SPY	ETF	117.92	118.53	117.86	118.2099	10975993.0
2010-10-28 13:30:00	SPY	ETF	118.2	118.33	118.07	118.2101	8003749.0
2010-10-28 14:00:00	SPY	ETF	118.21	118.45	118.17	118.33	7440465.0
2010-10-28 14:30:00	SPY	ETF	118.32	118.489	118.26	118.38	11996697.0
2010-10-28 15:00:00	SPY	ETF	118.38	118.55	118.19	118.35	13499438.0
2010-10-28 15:30:00	SPY	ETF	118.35	118.7	118.29	118.47	18466885.0
2010-10-28 16:00:00	SPY	ETF	118.47	118.875	118.055	118.41	7485840.0
2010-10-28 16:30:00	SPY	ETF	118.41	118.5	118.4	118.47	1878529.0
2010-10-28 17:00:00	SPY	ETF	118.45	118.52	118.38	118.43	111225.0
2010-10-28 17:30:00	SPY	ETF	118.4	118.41	118.33	118.33	144850.0
2010-10-28 18:00:00	SPY	ETF	118.38	118.44	118.37	118.39	126417.0
2010-10-28 18:30:00	SPY	ETF	118.39	118.42	118.37	118.42	17100.0
2010-10-28 19:00:00	SPY	ETF	118.44	118.44	118.37	118.37	5840.0
2010-10-28 19:30:00	SPY	ETF	118.39	118.43	118.35	118.39	28428.0
2010-10-28 04:00:00	QQQ	ETF	52.25	52.25	52.25	52.25	185.0
2010-10-28 05:00:00	QQQ	ETF	52.35	52.35	52.35	52.35	175.0
2010-10-28 05:30:00	QQQ	ETF	52.34	52.35	52.32	52.32	19000.0
2010-10-28 06:00:00	QQQ	ETF	52.32	52.32	52.32	52.32	1000.0
2010-10-28 06:30:00	QQQ	ETF	52.25	52.27	52.25	52.27	4100.0
2010-10-28 07:00:00	QQQ	ETF	52.24	52.25	52.23	52.25	29109.0
2010-10-28 07:30:00	QQQ	ETF	52.25	52.26	52.23	52.26	6200.0
2010-10-28 08:00:00	QQQ	ETF	52.25	52.42	52.25	52.39	119589.0
2010-10-28 08:30:00	QQQ	ETF	52.39	52.5	52.32	52.4	915769.0
2010-10-28 09:00:00	QQQ	ETF	52.4	52.44	52.36	52.43	315011.0
2010-10-28 09:30:00	QQQ	ETF	52.43	52.45	52.2	52.24	8136835.0
2010-10-28 10:00:00	QQQ	ETF	52.24	52.33	51.98	52.0199	9466182.0
2010-10-28 10:30:00	QQQ	ETF	52.02	52.06	51.94	52.04	4041222.0
2010-10-28 11:00:00	QQQ	ETF	52.035	52.17	52.02	52.12	2466380.0
2010-10-28 11:30:00	QQQ	ETF	52.12	52.14	52.0	52.01	2172486.0
2010-10-28 12:00:00	QQQ	ETF	52.0	52.0	51.89	51.93	3661111.0
2010-10-28 12:30:00	QQQ	ETF	51.93	51.99	51.87	51.895	3077744.0
2010-10-28 13:00:00	QQQ	ETF	51.89	52.19	51.84	52.09	3861510.0
2010-10-28 13:30:00	QQQ	ETF	52.1	52.17	52.02	52.1006	2196656.0

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

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