PREVIEW / etf_30min / 2009-10-22

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-22.parquet
  size:    237 KB
  rows:    7,636

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-10-22 04:00:00	SPY	ETF	108.04	108.04	107.92	107.95	1600.0
2009-10-22 04:30:00	SPY	ETF	107.98	107.98	107.67	107.83	2200.0
2009-10-22 05:00:00	SPY	ETF	107.84	107.9	107.79	107.8	4000.0
2009-10-22 05:30:00	SPY	ETF	107.85	107.88	107.85	107.88	10300.0
2009-10-22 06:00:00	SPY	ETF	108.02	108.02	108.0	108.0	10200.0
2009-10-22 06:30:00	SPY	ETF	107.91	108.14	107.87	108.14	35337.0
2009-10-22 07:00:00	SPY	ETF	108.14	108.17	108.0	108.04	94727.0
2009-10-22 07:30:00	SPY	ETF	108.13	108.22	108.09	108.19	891638.0
2009-10-22 08:00:00	SPY	ETF	108.17	108.5	107.91	108.33	3033704.0
2009-10-22 08:30:00	SPY	ETF	108.32	108.37	108.02	108.05	2711012.0
2009-10-22 09:00:00	SPY	ETF	108.06	108.25	107.98	108.19	1873503.0
2009-10-22 09:30:00	SPY	ETF	108.19	108.515	107.69	107.86	27344429.0
2009-10-22 10:00:00	SPY	ETF	107.86	108.16	107.5	108.02	27815315.0
2009-10-22 10:30:00	SPY	ETF	108.02	108.32	107.83	108.25	16824599.0
2009-10-22 11:00:00	SPY	ETF	108.2484	108.44	108.2	108.28	11401497.0
2009-10-22 11:30:00	SPY	ETF	108.28	108.51	108.19	108.25	10785063.0
2009-10-22 12:00:00	SPY	ETF	108.26	108.38	108.0	108.15	5713545.0
2009-10-22 12:30:00	SPY	ETF	108.1499	108.62	108.135	108.52	9505501.0
2009-10-22 13:00:00	SPY	ETF	108.51	108.58	108.36	108.4696	6256790.0
2009-10-22 13:30:00	SPY	ETF	108.46	108.57	108.37	108.54	7600413.0
2009-10-22 14:00:00	SPY	ETF	108.54	109.18	108.54	109.13	27623774.0
2009-10-22 14:30:00	SPY	ETF	109.12	109.31	109.1	109.24	16485054.0
2009-10-22 15:00:00	SPY	ETF	109.24	109.68	109.15	109.57	20533998.0
2009-10-22 15:30:00	SPY	ETF	109.57	109.59	109.26	109.33	23372821.0
2009-10-22 16:00:00	SPY	ETF	109.32	109.61	108.24	109.57	10495265.0
2009-10-22 16:30:00	SPY	ETF	109.53	109.6	109.46	109.54	3521145.0
2009-10-22 17:00:00	SPY	ETF	109.55	109.6	109.55	109.57	35710.0
2009-10-22 17:30:00	SPY	ETF	109.61	109.62	108.5	109.59	2532133.0
2009-10-22 18:00:00	SPY	ETF	109.58	109.67	109.58	109.64	44434.0
2009-10-22 18:30:00	SPY	ETF	109.64	109.74	109.6	109.74	71475.0
2009-10-22 19:00:00	SPY	ETF	109.72	109.8	109.72	109.8	28235.0
2009-10-22 19:30:00	SPY	ETF	109.81	109.82	109.76	109.8	110988.0
2009-10-22 04:00:00	QQQ	ETF	42.99	42.99	42.99	42.99	100.0
2009-10-22 04:30:00	QQQ	ETF	42.91	42.96	42.91	42.96	700.0
2009-10-22 05:00:00	QQQ	ETF	42.96	42.96	42.96	42.96	1200.0
2009-10-22 05:30:00	QQQ	ETF	43.02	43.02	43.02	43.02	200.0
2009-10-22 06:00:00	QQQ	ETF	43.03	43.03	42.98	42.98	300.0
2009-10-22 06:30:00	QQQ	ETF	43.01	43.01	42.99	43.01	5000.0
2009-10-22 07:00:00	QQQ	ETF	43.08	43.1	43.05	43.05	34500.0
2009-10-22 07:30:00	QQQ	ETF	43.08	43.09	43.07	43.09	9200.0
2009-10-22 08:00:00	QQQ	ETF	43.1	43.22	42.92	43.15	352153.0
2009-10-22 08:30:00	QQQ	ETF	43.15	43.15	42.97	43.04	1074422.0
2009-10-22 09:00:00	QQQ	ETF	43.03	43.11	43.01	43.08	652505.0
2009-10-22 09:30:00	QQQ	ETF	43.08	43.22	42.88	42.93	14134433.0
2009-10-22 10:00:00	QQQ	ETF	42.93	43.04	42.79	42.95	9364760.0
2009-10-22 10:30:00	QQQ	ETF	42.96	43.03	42.84	43.02	6261324.0
2009-10-22 11:00:00	QQQ	ETF	43.01	43.08	42.99	43.018	3485584.0
2009-10-22 11:30:00	QQQ	ETF	43.01	43.07	42.93	42.94	3427718.0
2009-10-22 12:00:00	QQQ	ETF	42.95	43.04	42.93	42.95	2131543.0
2009-10-22 12:30:00	QQQ	ETF	42.95	43.14	42.95	43.0805	3312483.0

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

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