PREVIEW / etf_30min / 2009-01-22

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-22.parquet
  size:    203 KB
  rows:    6,645

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-01-22 04:00:00	SPY	ETF	84.28	84.28	84.12	84.12	800.0
2009-01-22 04:30:00	SPY	ETF	84.16	84.38	84.07	84.38	2600.0
2009-01-22 05:00:00	SPY	ETF	84.17	84.17	83.95	83.95	1500.0
2009-01-22 05:30:00	SPY	ETF	84.1	84.1	83.7	83.7	1300.0
2009-01-22 06:00:00	SPY	ETF	83.68	83.8	83.33	83.35	58299.0
2009-01-22 06:30:00	SPY	ETF	83.35	83.56	83.25	83.53	13600.0
2009-01-22 07:00:00	SPY	ETF	83.72	83.85	83.66	83.78	590326.0
2009-01-22 07:30:00	SPY	ETF	83.8	83.87	83.7	83.72	230978.0
2009-01-22 08:00:00	SPY	ETF	83.72	84.07	83.48	83.63	1136204.0
2009-01-22 08:30:00	SPY	ETF	83.6	83.6	82.98	83.14	3372266.0
2009-01-22 09:00:00	SPY	ETF	83.15	83.17	82.24	82.41	5596704.0
2009-01-22 09:30:00	SPY	ETF	82.42	82.91	82.06	82.408	35509679.0
2009-01-22 10:00:00	SPY	ETF	82.395	82.97	82.26	82.48	26207821.0
2009-01-22 10:30:00	SPY	ETF	82.48	82.49	81.91	82.08	22833813.0
2009-01-22 11:00:00	SPY	ETF	82.08	82.38	81.72	81.9501	24870336.0
2009-01-22 11:30:00	SPY	ETF	81.95	81.955	81.21	81.3	23202810.0
2009-01-22 12:00:00	SPY	ETF	81.29	81.74	81.17	81.73	26235112.0
2009-01-22 12:30:00	SPY	ETF	81.72	82.32	81.58	82.02	24297474.0
2009-01-22 13:00:00	SPY	ETF	82.03	82.4	81.711	82.03	21793515.0
2009-01-22 13:30:00	SPY	ETF	82.02	82.98	81.78	82.98	27047467.0
2009-01-22 14:00:00	SPY	ETF	82.97	84.04	82.3	83.52	46126844.0
2009-01-22 14:30:00	SPY	ETF	83.52	83.78	82.73	83.221	40585129.0
2009-01-22 15:00:00	SPY	ETF	83.22	83.25	82.0	82.61	36018828.0
2009-01-22 15:30:00	SPY	ETF	82.61	83.4	82.11	82.78	42122277.0
2009-01-22 16:00:00	SPY	ETF	82.84	83.85	82.13	82.89	12968562.0
2009-01-22 16:30:00	SPY	ETF	82.88	84.0935	82.71	82.83	3296222.0
2009-01-22 17:00:00	SPY	ETF	82.84	82.94	82.78	82.93	89259.0
2009-01-22 17:30:00	SPY	ETF	82.84	82.95	82.84	82.94	50639.0
2009-01-22 18:00:00	SPY	ETF	82.94	82.96	82.81	82.86	162627.0
2009-01-22 18:30:00	SPY	ETF	82.85	83.0	82.83	82.99	112872.0
2009-01-22 19:00:00	SPY	ETF	82.99	83.09	82.75	82.75	40011.0
2009-01-22 19:30:00	SPY	ETF	82.73	82.75	82.65	82.7	41486.0
2009-01-22 04:00:00	QQQ	ETF	29.41	29.41	29.41	29.41	100.0
2009-01-22 04:30:00	QQQ	ETF	29.37	29.46	29.37	29.46	300.0
2009-01-22 05:00:00	QQQ	ETF	29.32	29.32	29.32	29.32	100.0
2009-01-22 05:30:00	QQQ	ETF	29.28	29.31	29.21	29.21	6400.0
2009-01-22 06:00:00	QQQ	ETF	29.23	29.31	29.1	29.2	95400.0
2009-01-22 06:30:00	QQQ	ETF	29.13	29.25	29.13	29.25	10700.0
2009-01-22 07:00:00	QQQ	ETF	29.26	29.36	29.25	29.36	237589.0
2009-01-22 07:30:00	QQQ	ETF	29.36	29.36	29.27	29.28	183850.0
2009-01-22 08:00:00	QQQ	ETF	29.28	29.35	29.09	29.25	1207266.0
2009-01-22 08:30:00	QQQ	ETF	29.24	29.26	29.01	29.02	1790868.0
2009-01-22 09:00:00	QQQ	ETF	29.04	29.04	28.43	28.53	8256841.0
2009-01-22 09:30:00	QQQ	ETF	28.53	28.75	28.42	28.61	24000659.0
2009-01-22 10:00:00	QQQ	ETF	28.61	28.8	28.5	28.6801	18336005.0
2009-01-22 10:30:00	QQQ	ETF	28.68	28.785	28.46	28.5	17293623.0
2009-01-22 11:00:00	QQQ	ETF	28.49	28.649	28.42	28.53	10801395.0
2009-01-22 11:30:00	QQQ	ETF	28.54	28.55	28.29	28.31	7512137.0
2009-01-22 12:00:00	QQQ	ETF	28.31	28.43	28.26	28.42	6184713.0
2009-01-22 12:30:00	QQQ	ETF	28.43	28.65	28.37	28.57	6367328.0

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

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