PREVIEW / etf_30min / 2009-07-31

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-31.parquet
  size:    223 KB
  rows:    7,447

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-07-31 04:30:00	SPY	ETF	98.78	98.78	98.78	98.78	1000.0
2009-07-31 05:00:00	SPY	ETF	98.8	98.83	98.8	98.83	200.0
2009-07-31 05:30:00	SPY	ETF	98.88	98.88	98.88	98.88	4980.0
2009-07-31 06:00:00	SPY	ETF	98.92	98.92	98.92	98.92	2500.0
2009-07-31 06:30:00	SPY	ETF	98.97	99.09	98.93	98.96	6100.0
2009-07-31 07:00:00	SPY	ETF	99.01	99.11	98.96	99.0	255983.0
2009-07-31 07:30:00	SPY	ETF	99.0	99.1	98.96	99.02	754397.0
2009-07-31 08:00:00	SPY	ETF	99.03	99.23	98.97	99.17	2963238.0
2009-07-31 08:30:00	SPY	ETF	99.25	99.53	98.27	98.33	7157368.0
2009-07-31 09:00:00	SPY	ETF	98.33	98.7	98.3	98.64	1419942.0
2009-07-31 09:30:00	SPY	ETF	98.65	99.46	98.56	98.92	32633577.0
2009-07-31 10:00:00	SPY	ETF	98.92	99.1	98.38	98.9	31788898.0
2009-07-31 10:30:00	SPY	ETF	98.9	99.27	98.84	99.09	11528244.0
2009-07-31 11:00:00	SPY	ETF	99.08	99.12	98.8	98.88	10273308.0
2009-07-31 11:30:00	SPY	ETF	98.88	99.16	98.72	99.03	8762686.0
2009-07-31 12:00:00	SPY	ETF	99.035	99.09	98.78	99.04	7532805.0
2009-07-31 12:30:00	SPY	ETF	99.04	99.07	98.78	98.9	4463076.0
2009-07-31 13:00:00	SPY	ETF	98.9	99.0	98.78	98.992	4876766.0
2009-07-31 13:30:00	SPY	ETF	98.99	99.18	98.95	99.1	7536874.0
2009-07-31 14:00:00	SPY	ETF	99.09	99.38	98.99	99.29	8924714.0
2009-07-31 14:30:00	SPY	ETF	99.2917	99.32	98.89	99.0	7979918.0
2009-07-31 15:00:00	SPY	ETF	98.99	99.47	98.94	99.3201	11794907.0
2009-07-31 15:30:00	SPY	ETF	99.33	99.33	98.69	98.83	29778477.0
2009-07-31 16:00:00	SPY	ETF	98.83	99.38	98.58	98.63	10703662.0
2009-07-31 16:30:00	SPY	ETF	99.39	99.39	98.62	98.8113	3759991.0
2009-07-31 17:00:00	SPY	ETF	98.75	98.77	98.72	98.75	32490.0
2009-07-31 17:30:00	SPY	ETF	98.76	98.76	98.68	98.71	24830.0
2009-07-31 18:00:00	SPY	ETF	98.7	98.74	98.69	98.7	12397.0
2009-07-31 18:30:00	SPY	ETF	98.7	98.7	98.6	98.68	19237.0
2009-07-31 19:00:00	SPY	ETF	98.68	98.68	98.63	98.68	8325.0
2009-07-31 19:30:00	SPY	ETF	98.68	98.7	98.63	98.68	18082.0
2009-07-31 05:30:00	QQQ	ETF	39.61	39.61	39.61	39.61	3000.0
2009-07-31 06:30:00	QQQ	ETF	39.61	39.66	39.61	39.66	2600.0
2009-07-31 07:00:00	QQQ	ETF	39.63	39.71	39.63	39.71	9400.0
2009-07-31 07:30:00	QQQ	ETF	39.69	39.71	39.68	39.69	16526.0
2009-07-31 08:00:00	QQQ	ETF	39.69	39.78	39.62	39.68	404571.0
2009-07-31 08:30:00	QQQ	ETF	39.75	39.8	39.41	39.44	1007968.0
2009-07-31 09:00:00	QQQ	ETF	39.44	39.56	39.42	39.56	542663.0
2009-07-31 09:30:00	QQQ	ETF	39.56	39.8522	39.55	39.6399	12088393.0
2009-07-31 10:00:00	QQQ	ETF	39.64	39.73	39.47	39.68	9525696.0
2009-07-31 10:30:00	QQQ	ETF	39.67	39.845	39.65	39.78	4814105.0
2009-07-31 11:00:00	QQQ	ETF	39.7899	39.81	39.68	39.7299	3768263.0
2009-07-31 11:30:00	QQQ	ETF	39.72	39.8	39.6701	39.73	4138201.0
2009-07-31 12:00:00	QQQ	ETF	39.73	39.76	39.65	39.74	3651795.0
2009-07-31 12:30:00	QQQ	ETF	39.74	39.76	39.61	39.66	1901849.0
2009-07-31 13:00:00	QQQ	ETF	39.66	39.7	39.63	39.695	1738593.0
2009-07-31 13:30:00	QQQ	ETF	39.71	39.76	39.67	39.69	2116290.0
2009-07-31 14:00:00	QQQ	ETF	39.6999	39.79	39.67	39.722	3775823.0
2009-07-31 14:30:00	QQQ	ETF	39.73	39.74	39.56	39.58	3497046.0
2009-07-31 15:00:00	QQQ	ETF	39.588	39.75	39.56	39.68	5043134.0

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

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