PREVIEW / etf_30min / 2010-02-03

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-02-03.parquet
  size:    240 KB
  rows:    8,057

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-02-03 04:00:00	SPY	ETF	110.38	110.44	110.38	110.44	2800.0
2010-02-03 04:30:00	SPY	ETF	110.32	110.34	110.28	110.34	2000.0
2010-02-03 05:00:00	SPY	ETF	110.38	110.41	110.38	110.38	2500.0
2010-02-03 05:30:00	SPY	ETF	110.18	110.29	110.18	110.29	4100.0
2010-02-03 06:00:00	SPY	ETF	110.27	110.27	110.27	110.27	500.0
2010-02-03 06:30:00	SPY	ETF	110.38	110.42	110.3	110.37	33850.0
2010-02-03 07:00:00	SPY	ETF	110.38	110.38	110.25	110.28	142935.0
2010-02-03 07:30:00	SPY	ETF	110.21	110.25	110.11	110.11	250529.0
2010-02-03 08:00:00	SPY	ETF	110.15	110.37	109.9	109.93	2706209.0
2010-02-03 08:30:00	SPY	ETF	109.92	110.01	109.73	109.84	2024194.0
2010-02-03 09:00:00	SPY	ETF	109.84	109.92	109.77	109.87	1688630.0
2010-02-03 09:30:00	SPY	ETF	109.88	110.42	109.84	110.36	20656413.0
2010-02-03 10:00:00	SPY	ETF	110.36	110.3617	109.83	109.85	16048265.0
2010-02-03 10:30:00	SPY	ETF	109.85	109.99	109.61	109.9	18102475.0
2010-02-03 11:00:00	SPY	ETF	109.9	110.09	109.8	109.84	9952803.0
2010-02-03 11:30:00	SPY	ETF	109.84	110.23	109.53	109.54	9972346.0
2010-02-03 12:00:00	SPY	ETF	109.55	109.84	109.51	109.67	8412835.0
2010-02-03 12:30:00	SPY	ETF	109.67	110.4815	109.67	109.83	7727439.0
2010-02-03 13:00:00	SPY	ETF	109.83	110.18	109.75	110.0	10269796.0
2010-02-03 13:30:00	SPY	ETF	110.005	110.18	109.85	109.9401	6701868.0
2010-02-03 14:00:00	SPY	ETF	109.95	110.02	109.76	109.83	6585543.0
2010-02-03 14:30:00	SPY	ETF	109.83	109.97	109.68	109.89	7220424.0
2010-02-03 15:00:00	SPY	ETF	109.89	110.13	109.73	109.88	11532951.0
2010-02-03 15:30:00	SPY	ETF	109.87	110.16	109.84	109.86	18496798.0
2010-02-03 16:00:00	SPY	ETF	109.85	110.15	109.82	110.09	5648012.0
2010-02-03 16:30:00	SPY	ETF	109.8832	110.4815	109.87	110.2	7771193.0
2010-02-03 17:00:00	SPY	ETF	110.19	110.31	110.17	110.18	161971.0
2010-02-03 17:30:00	SPY	ETF	110.2	110.28	110.2	110.24	58013.0
2010-02-03 18:00:00	SPY	ETF	110.24	110.31	109.82	110.29	48243.0
2010-02-03 18:30:00	SPY	ETF	110.27	110.27	110.18	110.2	31175.0
2010-02-03 19:00:00	SPY	ETF	110.17	110.22	110.17	110.21	21723.0
2010-02-03 19:30:00	SPY	ETF	110.21	110.21	110.03	110.05	87534.0
2010-02-03 04:00:00	QQQ	ETF	43.63	43.64	43.63	43.64	200.0
2010-02-03 04:30:00	QQQ	ETF	43.59	43.59	43.59	43.59	500.0
2010-02-03 06:30:00	QQQ	ETF	43.64	43.64	43.63	43.63	5500.0
2010-02-03 07:00:00	QQQ	ETF	43.65	43.65	43.62	43.63	4711.0
2010-02-03 07:30:00	QQQ	ETF	43.58	43.58	43.54	43.55	11661.0
2010-02-03 08:00:00	QQQ	ETF	43.55	43.66	43.46	43.47	193766.0
2010-02-03 08:30:00	QQQ	ETF	43.48	43.5	43.41	43.44	1374631.0
2010-02-03 09:00:00	QQQ	ETF	43.44	43.65	43.42	43.46	1476061.0
2010-02-03 09:30:00	QQQ	ETF	43.45	43.75	43.42	43.73	10658452.0
2010-02-03 10:00:00	QQQ	ETF	43.73	43.77	43.61	43.62	8231448.0
2010-02-03 10:30:00	QQQ	ETF	43.61	43.6799	43.47	43.64	7298772.0
2010-02-03 11:00:00	QQQ	ETF	43.6397	43.81	43.62	43.76	5205822.0
2010-02-03 11:30:00	QQQ	ETF	43.75	43.77	43.61	43.61	4490919.0
2010-02-03 12:00:00	QQQ	ETF	43.61	43.78	43.59	43.685	4355833.0
2010-02-03 12:30:00	QQQ	ETF	43.7	43.83	43.69	43.78	3764440.0
2010-02-03 13:00:00	QQQ	ETF	43.78	43.91	43.76	43.86	3695800.0
2010-02-03 13:30:00	QQQ	ETF	43.87	43.94	43.81	43.88	2659082.0
2010-02-03 14:00:00	QQQ	ETF	43.88	43.89	43.8	43.8301	2830697.0

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

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