PREVIEW / etf_30min / 2008-01-31

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-31.parquet
  size:    166 KB
  rows:    5,886

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
2008-01-31 04:00:00	SPY	ETF	134.15	134.33	134.15	134.33	600.0
2008-01-31 04:30:00	SPY	ETF	134.4	134.55	134.29	134.55	20200.0
2008-01-31 05:00:00	SPY	ETF	134.66	134.78	134.49	134.78	12000.0
2008-01-31 05:30:00	SPY	ETF	134.78	134.95	134.42	134.53	50900.0
2008-01-31 06:00:00	SPY	ETF	134.34	134.36	134.21	134.26	34700.0
2008-01-31 06:30:00	SPY	ETF	134.48	134.62	134.3	134.62	101100.0
2008-01-31 07:00:00	SPY	ETF	134.46	134.65	134.3	134.43	483200.0
2008-01-31 07:30:00	SPY	ETF	134.4	134.6	134.28	134.5	409200.0
2008-01-31 08:00:00	SPY	ETF	134.52	135.09	133.4	134.46	1508100.0
2008-01-31 08:30:00	SPY	ETF	134.42	134.46	133.02	133.22	8063900.0
2008-01-31 09:00:00	SPY	ETF	133.22	133.65	133.22	133.42	3339674.0
2008-01-31 09:30:00	SPY	ETF	133.4	134.51	133.2	134.42	28426053.0
2008-01-31 10:00:00	SPY	ETF	134.42	134.89	134.0	134.86	25718462.0
2008-01-31 10:30:00	SPY	ETF	134.87	135.22	134.33	135.17	19631310.0
2008-01-31 11:00:00	SPY	ETF	135.18	136.18	134.76	136.01	26760411.0
2008-01-31 11:30:00	SPY	ETF	136.01	137.46	135.66	136.79	28027820.0
2008-01-31 12:00:00	SPY	ETF	136.79	136.91	136.06	136.39	17926760.0
2008-01-31 12:30:00	SPY	ETF	136.4	136.65	135.84	136.15	14181544.0
2008-01-31 13:00:00	SPY	ETF	136.15	136.47	135.89	136.34	10331213.0
2008-01-31 13:30:00	SPY	ETF	136.35	137.07	136.28	136.65	13931414.0
2008-01-31 14:00:00	SPY	ETF	136.65	137.32	136.51	136.94	12288554.0
2008-01-31 14:30:00	SPY	ETF	136.97	137.57	136.63	137.53	17482698.0
2008-01-31 15:00:00	SPY	ETF	137.54	138.07	137.18	137.91	22032777.0
2008-01-31 15:30:00	SPY	ETF	137.91	138.54	136.93	137.33	41138462.0
2008-01-31 16:00:00	SPY	ETF	137.33	138.25	135.86	137.2	19361411.0
2008-01-31 16:30:00	SPY	ETF	137.18	137.8	134.38	137.21	16035200.0
2008-01-31 17:00:00	SPY	ETF	137.21	137.43	137.09	137.28	661800.0
2008-01-31 17:30:00	SPY	ETF	137.21	137.4	137.2	137.39	112500.0
2008-01-31 18:00:00	SPY	ETF	137.25	137.52	137.25	137.52	385000.0
2008-01-31 18:30:00	SPY	ETF	137.55	137.55	137.33	137.36	25200.0
2008-01-31 19:00:00	SPY	ETF	137.28	137.5	137.28	137.46	264100.0
2008-01-31 19:30:00	SPY	ETF	137.48	137.55	137.29	137.32	24400.0
2008-01-31 04:00:00	QQQ	ETF	44.05	44.05	44.05	44.05	2000.0
2008-01-31 04:30:00	QQQ	ETF	44.05	44.05	44.05	44.05	20000.0
2008-01-31 05:00:00	QQQ	ETF	44.15	44.15	44.15	44.15	600.0
2008-01-31 05:30:00	QQQ	ETF	44.18	44.18	44.18	44.18	200.0
2008-01-31 06:30:00	QQQ	ETF	44.13	44.17	44.13	44.17	2500.0
2008-01-31 07:00:00	QQQ	ETF	44.17	44.22	44.08	44.14	222879.0
2008-01-31 07:30:00	QQQ	ETF	44.14	44.21	44.08	44.19	194558.0
2008-01-31 08:00:00	QQQ	ETF	44.19	44.32	44.04	44.06	805556.0
2008-01-31 08:30:00	QQQ	ETF	44.04	44.05	43.75	43.76	3169266.0
2008-01-31 09:00:00	QQQ	ETF	43.77	43.88	43.75	43.86	1457135.0
2008-01-31 09:30:00	QQQ	ETF	43.87	44.12	43.82	44.06	22623414.0
2008-01-31 10:00:00	QQQ	ETF	44.06	44.25	43.99	44.19	21954530.0
2008-01-31 10:30:00	QQQ	ETF	44.195	44.25	43.98	44.23	13895747.0
2008-01-31 11:00:00	QQQ	ETF	44.23	44.61	44.11	44.55	16000267.0
2008-01-31 11:30:00	QQQ	ETF	44.55	45.03	44.46	44.87	23185699.0
2008-01-31 12:00:00	QQQ	ETF	44.88	44.8919	44.65	44.74	9919353.0
2008-01-31 12:30:00	QQQ	ETF	44.73	44.8666	44.58	44.68	8127260.0
2008-01-31 13:00:00	QQQ	ETF	44.69	44.76	44.59	44.72	6677139.0

> showing 50 of 5,886 rows — these rows as CSV

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