PREVIEW / etf_30min / 2009-12-28

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-28.parquet
  size:    230 KB
  rows:    7,813

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-12-28 04:00:00	SPY	ETF	112.64	112.65	112.64	112.65	400.0
2009-12-28 04:30:00	SPY	ETF	112.65	112.65	112.65	112.65	1976.0
2009-12-28 05:00:00	SPY	ETF	112.7	112.7	112.7	112.7	1000.0
2009-12-28 05:30:00	SPY	ETF	112.7	112.7	112.7	112.7	1000.0
2009-12-28 06:00:00	SPY	ETF	112.7	112.7	112.67	112.67	4200.0
2009-12-28 06:30:00	SPY	ETF	112.7	112.7	112.7	112.7	7500.0
2009-12-28 07:00:00	SPY	ETF	112.74	112.76	112.59	112.59	9515.0
2009-12-28 07:30:00	SPY	ETF	112.71	112.73	112.66	112.73	35641.0
2009-12-28 08:00:00	SPY	ETF	112.72	112.79	112.45	112.73	232769.0
2009-12-28 08:30:00	SPY	ETF	112.72	112.85	112.69	112.84	225679.0
2009-12-28 09:00:00	SPY	ETF	112.8	112.91	112.77	112.9	998576.0
2009-12-28 09:30:00	SPY	ETF	112.9	112.99	112.78	112.83	8505995.0
2009-12-28 10:00:00	SPY	ETF	112.83	112.86	112.63	112.7078	10431812.0
2009-12-28 10:30:00	SPY	ETF	112.7	112.71	112.59	112.65	2881606.0
2009-12-28 11:00:00	SPY	ETF	112.65	112.71	112.64	112.68	3587727.0
2009-12-28 11:30:00	SPY	ETF	112.69	112.75	112.62	112.6801	3346458.0
2009-12-28 12:00:00	SPY	ETF	112.69	112.69	112.6087	112.65	1682550.0
2009-12-28 12:30:00	SPY	ETF	112.65	112.7	112.62	112.6898	1041717.0
2009-12-28 13:00:00	SPY	ETF	112.68	112.75	112.67	112.69	1729759.0
2009-12-28 13:30:00	SPY	ETF	112.69	112.75	112.57	112.62	2269703.0
2009-12-28 14:00:00	SPY	ETF	112.63	112.65	112.32	112.34	5749538.0
2009-12-28 14:30:00	SPY	ETF	112.34	112.47	112.325	112.43	3330007.0
2009-12-28 15:00:00	SPY	ETF	112.44	112.5969	112.38	112.39	6098587.0
2009-12-28 15:30:00	SPY	ETF	112.4	112.76	112.39	112.74	12601232.0
2009-12-28 16:00:00	SPY	ETF	112.74	112.9	112.32	112.66	18053213.0
2009-12-28 16:30:00	SPY	ETF	112.66	112.87	112.5747	112.68	2613213.0
2009-12-28 17:00:00	SPY	ETF	112.68	112.7	112.64	112.64	828300.0
2009-12-28 17:30:00	SPY	ETF	112.64	112.66	112.64	112.66	450.0
2009-12-28 18:00:00	SPY	ETF	112.64	112.7	112.62	112.69	14550.0
2009-12-28 18:30:00	SPY	ETF	112.69	112.73	112.68	112.71	105045.0
2009-12-28 19:00:00	SPY	ETF	112.72	112.78	112.72	112.74	5300.0
2009-12-28 19:30:00	SPY	ETF	112.73	112.75	112.7	112.75	9425.0
2009-12-28 04:00:00	QQQ	ETF	45.98	46.03	45.98	46.03	500.0
2009-12-28 04:30:00	QQQ	ETF	46.08	46.08	46.07	46.07	613.0
2009-12-28 05:30:00	QQQ	ETF	46.13	46.13	46.13	46.13	10800.0
2009-12-28 06:00:00	QQQ	ETF	46.11	46.12	46.1	46.1	8000.0
2009-12-28 06:30:00	QQQ	ETF	46.12	46.12	46.12	46.12	2000.0
2009-12-28 07:00:00	QQQ	ETF	46.13	46.13	46.06	46.06	10800.0
2009-12-28 07:30:00	QQQ	ETF	46.08	46.09	46.06	46.08	60533.0
2009-12-28 08:00:00	QQQ	ETF	46.07	46.1	45.99	46.0	323686.0
2009-12-28 08:30:00	QQQ	ETF	46.0	46.08	45.97	46.08	133651.0
2009-12-28 09:00:00	QQQ	ETF	46.07	46.09	46.05	46.08	1035771.0
2009-12-28 09:30:00	QQQ	ETF	46.08	46.3	46.04	46.2	9476566.0
2009-12-28 10:00:00	QQQ	ETF	46.2	46.25	46.14	46.1899	4782571.0
2009-12-28 10:30:00	QQQ	ETF	46.1824	46.21	46.14	46.21	1206386.0
2009-12-28 11:00:00	QQQ	ETF	46.2	46.22	46.16	46.18	2011371.0
2009-12-28 11:30:00	QQQ	ETF	46.18	46.22	46.17	46.18	1404863.0
2009-12-28 12:00:00	QQQ	ETF	46.1801	46.21	46.16	46.19	1412254.0
2009-12-28 12:30:00	QQQ	ETF	46.18	46.2	46.16	46.19	850478.0
2009-12-28 13:00:00	QQQ	ETF	46.18	46.22	46.18	46.2001	1220884.0

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

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