PREVIEW / etf_30min / 2009-06-16

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-16.parquet
  size:    222 KB
  rows:    7,406

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
2009-06-16 04:00:00	SPY	ETF	92.75	92.75	92.6	92.6	3600.0
2009-06-16 04:30:00	SPY	ETF	92.81	92.81	92.74	92.74	200.0
2009-06-16 05:00:00	SPY	ETF	92.88	92.95	92.85	92.95	1100.0
2009-06-16 05:30:00	SPY	ETF	92.97	93.02	92.88	93.02	5600.0
2009-06-16 06:00:00	SPY	ETF	93.0	93.04	92.92	93.04	3800.0
2009-06-16 06:30:00	SPY	ETF	93.0	93.06	92.92	93.02	6229.0
2009-06-16 07:00:00	SPY	ETF	93.02	93.15	93.02	93.06	337764.0
2009-06-16 07:30:00	SPY	ETF	93.04	93.2	92.91	93.18	717441.0
2009-06-16 08:00:00	SPY	ETF	93.055	93.22	93.02	93.15	1567574.0
2009-06-16 08:30:00	SPY	ETF	93.17	93.34	93.02	93.17	2572348.0
2009-06-16 09:00:00	SPY	ETF	93.16	93.27	93.1	93.23	2436579.0
2009-06-16 09:30:00	SPY	ETF	93.23	93.29	92.9	93.03	22770789.0
2009-06-16 10:00:00	SPY	ETF	93.03	93.28	92.83	93.01	18583769.0
2009-06-16 10:30:00	SPY	ETF	93.01	93.2	92.91	93.09	7736611.0
2009-06-16 11:00:00	SPY	ETF	93.09	93.29	92.98	93.07	8776125.0
2009-06-16 11:30:00	SPY	ETF	93.07	93.25	92.63	92.65	11684106.0
2009-06-16 12:00:00	SPY	ETF	92.6599	92.77	92.58	92.675	9919787.0
2009-06-16 12:30:00	SPY	ETF	92.68	92.68	91.96	92.11	20311535.0
2009-06-16 13:00:00	SPY	ETF	92.11	92.12	91.75	91.95	14261804.0
2009-06-16 13:30:00	SPY	ETF	91.95	92.1	91.87	91.95	10478518.0
2009-06-16 14:00:00	SPY	ETF	91.95	91.96	91.64	91.73	14277898.0
2009-06-16 14:30:00	SPY	ETF	91.73	92.04	91.58	92.0	13883794.0
2009-06-16 15:00:00	SPY	ETF	92.01	92.19	91.8	91.99	15564008.0
2009-06-16 15:30:00	SPY	ETF	91.99	92.29	91.61	91.66	28709398.0
2009-06-16 16:00:00	SPY	ETF	91.65	93.2	91.58	91.73	9810041.0
2009-06-16 16:30:00	SPY	ETF	91.72	92.3749	91.6	91.68	11014294.0
2009-06-16 17:00:00	SPY	ETF	91.66	91.68	91.53	91.6	144437.0
2009-06-16 17:30:00	SPY	ETF	91.58	91.65	91.58	91.65	32650.0
2009-06-16 18:00:00	SPY	ETF	91.6	91.66	91.53	91.58	182577.0
2009-06-16 18:30:00	SPY	ETF	91.56	91.61	91.53	91.61	16171.0
2009-06-16 19:00:00	SPY	ETF	91.61	91.64	91.58	91.6	46368.0
2009-06-16 19:30:00	SPY	ETF	91.58	91.63	91.53	91.63	79031.0
2009-06-16 04:30:00	QQQ	ETF	35.89	35.9	35.89	35.9	200.0
2009-06-16 05:00:00	QQQ	ETF	35.93	35.93	35.92	35.92	300.0
2009-06-16 05:30:00	QQQ	ETF	35.91	35.95	35.91	35.95	400.0
2009-06-16 06:00:00	QQQ	ETF	35.96	35.96	35.96	35.96	100.0
2009-06-16 06:30:00	QQQ	ETF	35.99	36.01	35.99	35.99	5100.0
2009-06-16 07:00:00	QQQ	ETF	36.04	36.08	36.02	36.04	433712.0
2009-06-16 07:30:00	QQQ	ETF	36.05	36.09	36.02	36.09	35904.0
2009-06-16 08:00:00	QQQ	ETF	36.08	36.1	36.0	36.06	892830.0
2009-06-16 08:30:00	QQQ	ETF	36.05	36.13	36.04	36.05	700593.0
2009-06-16 09:00:00	QQQ	ETF	36.05	36.09	36.01	36.06	864856.0
2009-06-16 09:30:00	QQQ	ETF	36.06	36.14	35.9	36.05	13217970.0
2009-06-16 10:00:00	QQQ	ETF	36.05	36.17	35.96	36.04	10167038.0
2009-06-16 10:30:00	QQQ	ETF	36.06	36.13	36.02	36.1115	3769365.0
2009-06-16 11:00:00	QQQ	ETF	36.12	36.19	36.08	36.11	4251477.0
2009-06-16 11:30:00	QQQ	ETF	36.11	36.135	35.96	35.9699	4893857.0
2009-06-16 12:00:00	QQQ	ETF	35.96	36.04	35.94	35.97	4702155.0
2009-06-16 12:30:00	QQQ	ETF	35.97	35.97	35.65	35.73	9992547.0
2009-06-16 13:00:00	QQQ	ETF	35.74	35.75	35.64	35.73	7711102.0

> showing 50 of 7,406 rows — these rows as CSV

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