PREVIEW / etf_30min / 2008-12-19

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-12-19.parquet
  size:    191 KB
  rows:    6,760

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-12-19 04:00:00	SPY	ETF	88.89	88.9	88.8	88.87	1220.0
2008-12-19 04:30:00	SPY	ETF	88.85	88.92	88.77	88.77	1685.0
2008-12-19 05:00:00	SPY	ETF	88.71	89.0	88.45	88.45	3700.0
2008-12-19 05:30:00	SPY	ETF	88.44	88.88	88.35	88.81	3285.0
2008-12-19 06:00:00	SPY	ETF	88.74	88.76	88.51	88.55	4690.0
2008-12-19 06:30:00	SPY	ETF	88.5	88.7	88.33	88.7	44600.0
2008-12-19 07:00:00	SPY	ETF	88.7	88.72	88.38	88.53	290129.0
2008-12-19 07:30:00	SPY	ETF	88.53	88.8	88.51	88.77	813836.0
2008-12-19 08:00:00	SPY	ETF	88.75	89.42	88.2	89.05	2512763.0
2008-12-19 08:30:00	SPY	ETF	89.05	89.75	89.01	89.68	3279732.0
2008-12-19 09:00:00	SPY	ETF	89.68	89.9	89.0	89.12	4779277.0
2008-12-19 09:30:00	SPY	ETF	89.1	89.61	88.73	89.0899	30521225.0
2008-12-19 10:00:00	SPY	ETF	89.08	90.62	89.04	90.18	25368806.0
2008-12-19 10:30:00	SPY	ETF	90.18	90.38	89.83	89.9	17051684.0
2008-12-19 11:00:00	SPY	ETF	89.9	89.98	89.49	89.53	20298686.0
2008-12-19 11:30:00	SPY	ETF	89.54	89.7	88.75	88.83	22795391.0
2008-12-19 12:00:00	SPY	ETF	88.84	88.92	88.39	88.8308	18665261.0
2008-12-19 12:30:00	SPY	ETF	88.83	89.07	88.68	88.845	17193881.0
2008-12-19 13:00:00	SPY	ETF	88.84	89.27	88.81	89.21	10611670.0
2008-12-19 13:30:00	SPY	ETF	89.1916	89.92	88.86	88.98	11343208.0
2008-12-19 14:00:00	SPY	ETF	88.98	89.27	88.61	88.8217	14032079.0
2008-12-19 14:30:00	SPY	ETF	88.8208	89.3391	88.6	88.78	18137986.0
2008-12-19 15:00:00	SPY	ETF	88.79	89.1181	88.09	88.64	22825602.0
2008-12-19 15:30:00	SPY	ETF	88.63	88.73	88.16	88.39	34051318.0
2008-12-19 16:00:00	SPY	ETF	88.32	89.8694	87.8	88.26	19208100.0
2008-12-19 16:30:00	SPY	ETF	88.26	88.59	88.12	88.2	997722.0
2008-12-19 17:00:00	SPY	ETF	88.19	88.2	88.06	88.12	88858.0
2008-12-19 17:30:00	SPY	ETF	88.12	88.19	88.11	88.15	43178.0
2008-12-19 18:00:00	SPY	ETF	88.15	88.18	88.15	88.18	32277.0
2008-12-19 18:30:00	SPY	ETF	88.18	88.21	88.17	88.19	16401.0
2008-12-19 19:00:00	SPY	ETF	88.22	88.24	88.21	88.21	9650.0
2008-12-19 19:30:00	SPY	ETF	88.22	88.24	88.18	88.19	9041.0
2008-12-19 04:00:00	QQQ	ETF	29.83	29.83	29.83	29.83	200.0
2008-12-19 05:00:00	QQQ	ETF	29.73	29.73	29.73	29.73	100.0
2008-12-19 06:00:00	QQQ	ETF	29.83	29.83	29.83	29.83	100.0
2008-12-19 06:30:00	QQQ	ETF	29.75	29.75	29.75	29.75	5200.0
2008-12-19 07:00:00	QQQ	ETF	29.76	29.84	29.72	29.77	37751.0
2008-12-19 07:30:00	QQQ	ETF	29.74	29.8	29.72	29.8	60820.0
2008-12-19 08:00:00	QQQ	ETF	29.68	30.01	29.68	29.88	404935.0
2008-12-19 08:30:00	QQQ	ETF	29.89	30.04	29.87	30.0	1498676.0
2008-12-19 09:00:00	QQQ	ETF	30.02	30.08	29.88	29.99	1104295.0
2008-12-19 09:30:00	QQQ	ETF	29.98	30.21	29.93	30.05	17887502.0
2008-12-19 10:00:00	QQQ	ETF	30.06	30.3	30.05	30.271	11595285.0
2008-12-19 10:30:00	QQQ	ETF	30.28	30.37	30.19	30.25	7432920.0
2008-12-19 11:00:00	QQQ	ETF	30.25	30.28	30.1	30.12	5214579.0
2008-12-19 11:30:00	QQQ	ETF	30.12	30.21	29.91	29.93	7091518.0
2008-12-19 12:00:00	QQQ	ETF	29.9305	29.9826	29.77	29.9005	8266107.0
2008-12-19 12:30:00	QQQ	ETF	29.9	29.97	29.85	29.9	3855028.0
2008-12-19 13:00:00	QQQ	ETF	29.9	30.03	29.88	29.98	3995786.0
2008-12-19 13:30:00	QQQ	ETF	29.98	30.09	29.92	29.99	4339176.0

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

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