PREVIEW / etf_30min / 2010-01-21

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-21.parquet
  size:    255 KB
  rows:    8,468

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-21 04:00:00	SPY	ETF	113.91	113.91	113.91	113.91	300.0
2010-01-21 04:30:00	SPY	ETF	113.85	113.85	113.84	113.84	400.0
2010-01-21 05:00:00	SPY	ETF	113.82	113.87	113.78	113.85	6800.0
2010-01-21 05:30:00	SPY	ETF	113.77	113.77	113.6	113.61	1478.0
2010-01-21 06:00:00	SPY	ETF	113.69	113.69	113.6	113.6	3300.0
2010-01-21 06:30:00	SPY	ETF	113.75	113.9	113.7	113.87	900.0
2010-01-21 07:00:00	SPY	ETF	113.99	114.06	113.93	114.05	45847.0
2010-01-21 07:30:00	SPY	ETF	114.08	114.19	114.0	114.02	302338.0
2010-01-21 08:00:00	SPY	ETF	114.04	114.27	113.78	114.02	3397095.0
2010-01-21 08:30:00	SPY	ETF	114.01	114.01	113.55	113.7	3440132.0
2010-01-21 09:00:00	SPY	ETF	113.7	113.98	113.67	113.93	1443458.0
2010-01-21 09:30:00	SPY	ETF	113.92	114.27	113.73	113.84	27777436.0
2010-01-21 10:00:00	SPY	ETF	113.85	114.14	112.69	112.725	33048201.0
2010-01-21 10:30:00	SPY	ETF	112.72	112.8	112.38	112.61	33113050.0
2010-01-21 11:00:00	SPY	ETF	112.62	112.66	112.11	112.26	20384414.0
2010-01-21 11:30:00	SPY	ETF	112.26	112.35	111.62	111.88	39365601.0
2010-01-21 12:00:00	SPY	ETF	111.88	112.31	111.74	111.8	20450025.0
2010-01-21 12:30:00	SPY	ETF	111.79	111.96	111.65	111.75	19222070.0
2010-01-21 13:00:00	SPY	ETF	111.75	111.93	111.56	111.885	14328032.0
2010-01-21 13:30:00	SPY	ETF	111.89	112.14	111.88	112.05	15725616.0
2010-01-21 14:00:00	SPY	ETF	112.05	112.3	111.77	112.26	19955628.0
2010-01-21 14:30:00	SPY	ETF	112.26	112.42	111.99	112.092	16243186.0
2010-01-21 15:00:00	SPY	ETF	112.09	112.24	111.66	111.81	23380115.0
2010-01-21 15:30:00	SPY	ETF	111.81	112.14	111.66	111.68	32852039.0
2010-01-21 16:00:00	SPY	ETF	111.67	111.85	111.4	111.45	8449401.0
2010-01-21 16:30:00	SPY	ETF	111.44	113.8976	111.3	111.45	4579197.0
2010-01-21 17:00:00	SPY	ETF	111.44	113.8976	111.34	111.35	3926498.0
2010-01-21 17:30:00	SPY	ETF	111.35	113.8975	111.34	111.34	2033335.0
2010-01-21 18:00:00	SPY	ETF	111.33	111.5	111.33	111.5	30681.0
2010-01-21 18:30:00	SPY	ETF	111.49	111.51	111.42	111.51	23246.0
2010-01-21 19:00:00	SPY	ETF	111.45	111.5	111.45	111.49	2150.0
2010-01-21 19:30:00	SPY	ETF	111.49	111.58	111.47	111.53	56401.0
2010-01-21 05:30:00	QQQ	ETF	45.84	45.84	45.84	45.84	400.0
2010-01-21 06:00:00	QQQ	ETF	45.85	45.86	45.83	45.83	4700.0
2010-01-21 06:30:00	QQQ	ETF	45.87	45.92	45.86	45.92	30400.0
2010-01-21 07:00:00	QQQ	ETF	45.95	45.98	45.93	45.97	23278.0
2010-01-21 07:30:00	QQQ	ETF	45.97	46.04	45.97	46.0	62623.0
2010-01-21 08:00:00	QQQ	ETF	45.99	46.06	45.92	46.04	2526329.0
2010-01-21 08:30:00	QQQ	ETF	46.04	46.04	45.84	45.92	1132529.0
2010-01-21 09:00:00	QQQ	ETF	45.93	46.1	45.92	46.06	848419.0
2010-01-21 09:30:00	QQQ	ETF	46.06	46.29	46.01	46.13	16104759.0
2010-01-21 10:00:00	QQQ	ETF	46.14	46.35	45.64	45.65	24620109.0
2010-01-21 10:30:00	QQQ	ETF	45.65	45.71	45.48	45.6104	24565976.0
2010-01-21 11:00:00	QQQ	ETF	45.62	45.68	45.43	45.5	8424900.0
2010-01-21 11:30:00	QQQ	ETF	45.51	45.65	45.3	45.42	20437053.0
2010-01-21 12:00:00	QQQ	ETF	45.43	45.6423	45.32	45.34	12643164.0
2010-01-21 12:30:00	QQQ	ETF	45.35	45.44	45.32	45.38	6766513.0
2010-01-21 13:00:00	QQQ	ETF	45.39	45.5	45.3	45.475	8278891.0
2010-01-21 13:30:00	QQQ	ETF	45.48	45.6	45.47	45.57	8494660.0
2010-01-21 14:00:00	QQQ	ETF	45.5732	45.69	45.46	45.66	11124952.0

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

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