PREVIEW / etf_30min / 2010-05-21

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-21.parquet
  size:    281 KB
  rows:    9,463

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-05-21 04:00:00	SPY	ETF	108.06	108.09	107.88	107.99	3450.0
2010-05-21 04:30:00	SPY	ETF	108.11	108.25	108.0	108.0	4200.0
2010-05-21 05:00:00	SPY	ETF	107.89	108.25	107.89	108.13	24250.0
2010-05-21 05:30:00	SPY	ETF	108.0	108.11	107.6	107.82	43833.0
2010-05-21 06:00:00	SPY	ETF	107.7	107.91	107.59	107.72	20800.0
2010-05-21 06:30:00	SPY	ETF	107.59	107.59	106.9	107.2	112183.0
2010-05-21 07:00:00	SPY	ETF	107.14	107.35	106.49	106.49	1021964.0
2010-05-21 07:30:00	SPY	ETF	106.48	106.92	106.26	106.87	1986359.0
2010-05-21 08:00:00	SPY	ETF	106.49	108.25	106.26	106.42	4224979.0
2010-05-21 08:30:00	SPY	ETF	106.41	106.88	106.3	106.74	6030777.0
2010-05-21 09:00:00	SPY	ETF	106.74	106.74	105.72	105.91	9056581.0
2010-05-21 09:30:00	SPY	ETF	105.91	108.1	105.64	107.72	97132745.0
2010-05-21 10:00:00	SPY	ETF	107.73	108.46	107.19	107.3	47920579.0
2010-05-21 10:30:00	SPY	ETF	107.31	108.06	107.15	107.73	29203097.0
2010-05-21 11:00:00	SPY	ETF	107.72	108.8	107.54	108.655	34114751.0
2010-05-21 11:30:00	SPY	ETF	108.63	109.38	108.41	109.04	33992829.0
2010-05-21 12:00:00	SPY	ETF	109.04	109.23	108.66	109.03	20411671.0
2010-05-21 12:30:00	SPY	ETF	109.03	109.13	108.44	108.56	15952730.0
2010-05-21 13:00:00	SPY	ETF	108.56	108.85	108.17	108.31	15541211.0
2010-05-21 13:30:00	SPY	ETF	108.31	108.83	108.26	108.75	15031415.0
2010-05-21 14:00:00	SPY	ETF	108.75	108.94	108.03	108.3	26182495.0
2010-05-21 14:30:00	SPY	ETF	108.3	108.49	107.62	108.04	19532228.0
2010-05-21 15:00:00	SPY	ETF	108.04	108.22	107.3	107.82	30429459.0
2010-05-21 15:30:00	SPY	ETF	107.83	109.18	107.46	109.1	66892931.0
2010-05-21 16:00:00	SPY	ETF	109.08	109.1221	106.61	108.97	20182403.0
2010-05-21 16:30:00	SPY	ETF	108.97	109.02	107.75	108.97	3350342.0
2010-05-21 17:00:00	SPY	ETF	108.99	109.1197	108.62	108.99	995844.0
2010-05-21 17:30:00	SPY	ETF	108.99	109.19	108.98	109.15	79327.0
2010-05-21 18:00:00	SPY	ETF	109.15	109.33	109.1	109.33	157337.0
2010-05-21 18:30:00	SPY	ETF	109.33	109.33	109.03	109.29	44584.0
2010-05-21 19:00:00	SPY	ETF	109.29	109.29	109.22	109.27	19244.0
2010-05-21 19:30:00	SPY	ETF	109.27	109.35	109.22	109.28	62587.0
2010-05-21 04:00:00	QQQ	ETF	44.51	44.51	44.47	44.47	600.0
2010-05-21 04:30:00	QQQ	ETF	44.56	44.61	44.56	44.57	1208.0
2010-05-21 05:00:00	QQQ	ETF	44.6	44.6	44.6	44.6	300.0
2010-05-21 05:30:00	QQQ	ETF	44.45	44.45	44.42	44.42	20000.0
2010-05-21 06:00:00	QQQ	ETF	44.4	44.4	44.4	44.4	40000.0
2010-05-21 06:30:00	QQQ	ETF	44.34	44.35	44.15	44.2	12358.0
2010-05-21 07:00:00	QQQ	ETF	44.24	44.28	43.89	43.92	139561.0
2010-05-21 07:30:00	QQQ	ETF	43.9	44.08	43.76	44.02	179456.0
2010-05-21 08:00:00	QQQ	ETF	44.06	44.6	43.79	43.87	587517.0
2010-05-21 08:30:00	QQQ	ETF	43.89	44.07	43.8	44.01	630753.0
2010-05-21 09:00:00	QQQ	ETF	44.0	44.0	43.6	43.64	2103525.0
2010-05-21 09:30:00	QQQ	ETF	43.64	44.68	43.49	44.42	42223097.0
2010-05-21 10:00:00	QQQ	ETF	44.42	44.68	44.17	44.2201	19033126.0
2010-05-21 10:30:00	QQQ	ETF	44.22	44.6201	44.16	44.46	12661945.0
2010-05-21 11:00:00	QQQ	ETF	44.4501	44.89	44.43	44.85	9823503.0
2010-05-21 11:30:00	QQQ	ETF	44.85	45.17	44.77	44.99	11798685.0
2010-05-21 12:00:00	QQQ	ETF	44.99	45.15	44.83	45.0102	7139548.0
2010-05-21 12:30:00	QQQ	ETF	45.01	45.0696	44.76	44.81	6956504.0

> showing 50 of 9,463 rows — these rows as CSV

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