PREVIEW / etf_30min / 2010-01-20

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-20.parquet
  size:    254 KB
  rows:    8,404

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-01-20 04:00:00	SPY	ETF	114.63	114.79	114.63	114.7	2800.0
2010-01-20 04:30:00	SPY	ETF	114.65	114.65	114.56	114.58	4148.0
2010-01-20 05:00:00	SPY	ETF	114.51	114.56	114.51	114.55	900.0
2010-01-20 05:30:00	SPY	ETF	114.68	114.68	114.68	114.68	100.0
2010-01-20 06:00:00	SPY	ETF	114.65	114.65	114.5	114.5	4033.0
2010-01-20 06:30:00	SPY	ETF	114.5	114.5	114.38	114.38	23825.0
2010-01-20 07:00:00	SPY	ETF	114.39	114.43	114.29	114.38	215909.0
2010-01-20 07:30:00	SPY	ETF	114.38	114.54	114.31	114.54	210162.0
2010-01-20 08:00:00	SPY	ETF	114.55	114.74	114.39	114.44	2659324.0
2010-01-20 08:30:00	SPY	ETF	114.43	114.55	114.22	114.26	2413612.0
2010-01-20 09:00:00	SPY	ETF	114.26	114.29	114.13	114.28	2855519.0
2010-01-20 09:30:00	SPY	ETF	114.28	114.45	113.76	113.97	30016762.0
2010-01-20 10:00:00	SPY	ETF	113.96	114.2	113.44	113.445	18808012.0
2010-01-20 10:30:00	SPY	ETF	113.4401	113.65	113.27	113.3199	17248516.0
2010-01-20 11:00:00	SPY	ETF	113.318	113.37	112.98	113.3	19765680.0
2010-01-20 11:30:00	SPY	ETF	113.3	113.31	113.17	113.22	10221614.0
2010-01-20 12:00:00	SPY	ETF	113.22	113.44	113.11	113.35	12488419.0
2010-01-20 12:30:00	SPY	ETF	113.3483	113.4	113.15	113.259	10292369.0
2010-01-20 13:00:00	SPY	ETF	113.2528	113.27	113.04	113.2	8424213.0
2010-01-20 13:30:00	SPY	ETF	113.2001	113.55	113.15	113.46	8732012.0
2010-01-20 14:00:00	SPY	ETF	113.45	113.58	113.38	113.44	9979531.0
2010-01-20 14:30:00	SPY	ETF	113.4401	113.74	113.4	113.7	11178915.0
2010-01-20 15:00:00	SPY	ETF	113.7	113.86	113.61	113.79	9843746.0
2010-01-20 15:30:00	SPY	ETF	113.79	114.0	113.64	113.89	23116630.0
2010-01-20 16:00:00	SPY	ETF	113.89	115.1136	113.25	113.88	13932222.0
2010-01-20 16:30:00	SPY	ETF	113.89	113.99	113.3478	113.3478	2821658.0
2010-01-20 17:00:00	SPY	ETF	113.94	113.98	113.92	113.98	46452.0
2010-01-20 17:30:00	SPY	ETF	113.98	114.06	113.97	114.04	75537.0
2010-01-20 18:00:00	SPY	ETF	114.0	114.06	113.9	114.01	78101.0
2010-01-20 18:30:00	SPY	ETF	114.0	114.02	113.95	114.02	24025.0
2010-01-20 19:00:00	SPY	ETF	114.03	114.14	114.0	114.14	27595.0
2010-01-20 19:30:00	SPY	ETF	114.14	114.15	114.05	114.08	29755.0
2010-01-20 04:00:00	QQQ	ETF	46.4	46.4	46.38	46.38	200.0
2010-01-20 04:30:00	QQQ	ETF	46.3	46.33	46.3	46.33	3633.0
2010-01-20 05:00:00	QQQ	ETF	46.32	46.33	46.31	46.33	2500.0
2010-01-20 05:30:00	QQQ	ETF	46.33	46.35	46.33	46.33	3000.0
2010-01-20 06:00:00	QQQ	ETF	46.35	46.35	46.28	46.29	8021.0
2010-01-20 06:30:00	QQQ	ETF	46.3	46.3	46.25	46.25	5333.0
2010-01-20 07:00:00	QQQ	ETF	46.22	46.25	46.19	46.22	79424.0
2010-01-20 07:30:00	QQQ	ETF	46.28	46.34	46.24	46.33	278798.0
2010-01-20 08:00:00	QQQ	ETF	46.28	46.41	46.28	46.3	516679.0
2010-01-20 08:30:00	QQQ	ETF	46.29	46.38	46.25	46.28	1232497.0
2010-01-20 09:00:00	QQQ	ETF	46.28	46.29	46.22	46.27	1199695.0
2010-01-20 09:30:00	QQQ	ETF	46.27	46.28	46.03	46.06	15557467.0
2010-01-20 10:00:00	QQQ	ETF	46.05	46.1	45.59	45.62	23464216.0
2010-01-20 10:30:00	QQQ	ETF	45.618	45.7699	45.58	45.61	13271739.0
2010-01-20 11:00:00	QQQ	ETF	45.62	45.66	45.43	45.605	9942130.0
2010-01-20 11:30:00	QQQ	ETF	45.6	45.68	45.5701	45.6301	7079947.0
2010-01-20 12:00:00	QQQ	ETF	45.6399	45.73	45.58	45.668	4698463.0
2010-01-20 12:30:00	QQQ	ETF	45.67	45.69	45.56	45.6	3454737.0

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

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