PREVIEW / etf_30min / 2008-01-23

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-23.parquet
  size:    172 KB
  rows:    6,171

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-23 04:00:00	SPY	ETF	130.04	130.22	130.04	130.11	5000.0
2008-01-23 04:30:00	SPY	ETF	129.7	129.71	129.34	129.71	5100.0
2008-01-23 05:00:00	SPY	ETF	129.71	129.77	129.52	129.65	7000.0
2008-01-23 05:30:00	SPY	ETF	129.6	129.6	129.0	129.27	10400.0
2008-01-23 06:00:00	SPY	ETF	129.37	129.45	128.2	128.35	608600.0
2008-01-23 06:30:00	SPY	ETF	128.34	128.85	128.32	128.55	239400.0
2008-01-23 07:00:00	SPY	ETF	128.8	129.47	128.67	129.15	925000.0
2008-01-23 07:30:00	SPY	ETF	129.15	129.31	128.25	128.35	1174200.0
2008-01-23 08:00:00	SPY	ETF	128.98	130.92	127.03	127.53	12801400.0
2008-01-23 08:30:00	SPY	ETF	127.37	128.33	126.02	127.11	11660350.0
2008-01-23 09:00:00	SPY	ETF	127.08	127.8	126.94	127.14	6062590.0
2008-01-23 09:30:00	SPY	ETF	127.17	129.46	127.05	129.23	49159459.0
2008-01-23 10:00:00	SPY	ETF	129.24	131.0	128.97	129.953	47717106.0
2008-01-23 10:30:00	SPY	ETF	129.98	130.16	128.94	129.6	31556208.0
2008-01-23 11:00:00	SPY	ETF	129.6	129.99	129.1	129.26	19491250.0
2008-01-23 11:30:00	SPY	ETF	129.26	130.9691	128.24	128.5	23023328.0
2008-01-23 12:00:00	SPY	ETF	128.5	129.8	128.0	128.75	20635179.0
2008-01-23 12:30:00	SPY	ETF	128.743	130.9691	126.84	127.64	31782227.0
2008-01-23 13:00:00	SPY	ETF	127.64	128.73	127.22	128.42	27537276.0
2008-01-23 13:30:00	SPY	ETF	128.42	129.56	127.88	129.19	27896063.0
2008-01-23 14:00:00	SPY	ETF	129.18	130.72	128.86	130.53	31657692.0
2008-01-23 14:30:00	SPY	ETF	130.54	130.63	129.2	130.1	26844906.0
2008-01-23 15:00:00	SPY	ETF	130.11	132.88	129.97	132.7	55894746.0
2008-01-23 15:30:00	SPY	ETF	132.7	133.88	131.0	133.81	50321798.0
2008-01-23 16:00:00	SPY	ETF	133.7901	134.4	129.04	134.03	15676400.0
2008-01-23 16:30:00	SPY	ETF	134.01	134.5	133.83	134.07	1867200.0
2008-01-23 17:00:00	SPY	ETF	134.07	134.33	130.97	134.2	4576800.0
2008-01-23 17:30:00	SPY	ETF	134.21	134.34	134.21	134.34	72100.0
2008-01-23 18:00:00	SPY	ETF	134.34	134.65	134.34	134.43	185200.0
2008-01-23 18:30:00	SPY	ETF	134.39	134.39	134.01	134.16	65100.0
2008-01-23 19:00:00	SPY	ETF	134.1	134.17	134.05	134.17	32200.0
2008-01-23 19:30:00	SPY	ETF	134.17	134.24	134.05	134.18	397700.0
2008-01-23 06:00:00	QQQ	ETF	43.53	43.53	42.92	43.08	28100.0
2008-01-23 06:30:00	QQQ	ETF	43.06	43.1	43.03	43.08	85700.0
2008-01-23 07:00:00	QQQ	ETF	43.13	43.22	43.08	43.14	416623.0
2008-01-23 07:30:00	QQQ	ETF	43.14	43.16	42.82	42.93	580834.0
2008-01-23 08:00:00	QQQ	ETF	42.93	43.619	42.46	42.56	3057278.0
2008-01-23 08:30:00	QQQ	ETF	42.53	42.7	42.25	42.51	4292801.0
2008-01-23 09:00:00	QQQ	ETF	42.51	42.65	42.37	42.54	3147235.0
2008-01-23 09:30:00	QQQ	ETF	42.55	43.07	42.5	43.01	30532957.0
2008-01-23 10:00:00	QQQ	ETF	43.0401	43.41	42.85	43.1001	26852425.0
2008-01-23 10:30:00	QQQ	ETF	43.1	43.2	42.83	42.99	20218915.0
2008-01-23 11:00:00	QQQ	ETF	42.9999	43.04	42.53	42.55	16733618.0
2008-01-23 11:30:00	QQQ	ETF	42.54	42.55	42.14	42.1695	27178261.0
2008-01-23 12:00:00	QQQ	ETF	42.16	42.4	41.94	42.23	21910626.0
2008-01-23 12:30:00	QQQ	ETF	42.2301	42.25	41.61	41.91	25016737.0
2008-01-23 13:00:00	QQQ	ETF	41.92	42.24	41.77	42.1	15629228.0
2008-01-23 13:30:00	QQQ	ETF	42.1	42.4	41.95	42.32	20052372.0
2008-01-23 14:00:00	QQQ	ETF	42.32	42.98	42.18	42.94	24827196.0
2008-01-23 14:30:00	QQQ	ETF	42.95	42.95	42.38	42.7	29274984.0

> showing 50 of 6,171 rows — these rows as CSV

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