PREVIEW / etf_30min / 2009-10-05

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-05.parquet
  size:    230 KB
  rows:    7,594

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-05 04:00:00	SPY	ETF	103.3	103.3	103.3	103.3	952.0
2009-10-05 04:30:00	SPY	ETF	103.2	103.2	103.09	103.16	400.0
2009-10-05 05:00:00	SPY	ETF	103.26	103.26	103.14	103.14	1100.0
2009-10-05 05:30:00	SPY	ETF	103.12	103.15	103.1	103.1	1300.0
2009-10-05 06:00:00	SPY	ETF	103.21	103.24	103.14	103.24	13300.0
2009-10-05 06:30:00	SPY	ETF	103.21	103.26	103.18	103.26	4100.0
2009-10-05 07:00:00	SPY	ETF	103.25	103.25	103.17	103.19	113456.0
2009-10-05 07:30:00	SPY	ETF	103.2	103.28	103.15	103.25	109257.0
2009-10-05 08:00:00	SPY	ETF	103.25	103.26	103.0	103.01	382607.0
2009-10-05 08:30:00	SPY	ETF	103.0	103.13	102.88	102.93	732729.0
2009-10-05 09:00:00	SPY	ETF	102.92	103.03	102.9	102.91	2300686.0
2009-10-05 09:30:00	SPY	ETF	102.9	103.46	102.6	103.34	22915435.0
2009-10-05 10:00:00	SPY	ETF	103.335	103.58	102.76	103.21	24488940.0
2009-10-05 10:30:00	SPY	ETF	103.21	103.62	103.14	103.6	10440240.0
2009-10-05 11:00:00	SPY	ETF	103.605	103.72	103.4	103.48	11114636.0
2009-10-05 11:30:00	SPY	ETF	103.48	103.65	103.28	103.54	7024974.0
2009-10-05 12:00:00	SPY	ETF	103.53	103.65	103.47	103.53	3864173.0
2009-10-05 12:30:00	SPY	ETF	103.52	103.84	103.51	103.76	6874209.0
2009-10-05 13:00:00	SPY	ETF	103.76	103.86	103.72	103.78	3683299.0
2009-10-05 13:30:00	SPY	ETF	103.79	103.82	103.64	103.77	3538891.0
2009-10-05 14:00:00	SPY	ETF	103.76	103.82	103.59	103.74	6542094.0
2009-10-05 14:30:00	SPY	ETF	103.74	104.32	103.735	104.16	12962909.0
2009-10-05 15:00:00	SPY	ETF	104.16	104.26	104.09	104.16	9140941.0
2009-10-05 15:30:00	SPY	ETF	104.16	104.2	103.96	104.03	16925339.0
2009-10-05 16:00:00	SPY	ETF	104.03	104.18	102.552	104.13	5585354.0
2009-10-05 16:30:00	SPY	ETF	104.15	104.2	104.01	104.17	240894.0
2009-10-05 17:00:00	SPY	ETF	104.18	104.24	104.04	104.1	341550.0
2009-10-05 17:30:00	SPY	ETF	104.08	104.08	104.02	104.07	60046.0
2009-10-05 18:00:00	SPY	ETF	104.08	104.13	104.06	104.12	14236.0
2009-10-05 18:30:00	SPY	ETF	104.13	104.14	104.11	104.12	18995.0
2009-10-05 19:00:00	SPY	ETF	104.11	104.18	104.11	104.18	5500.0
2009-10-05 19:30:00	SPY	ETF	104.18	104.18	104.08	104.09	45472.0
2009-10-05 04:30:00	QQQ	ETF	41.2	41.2	41.14	41.14	4600.0
2009-10-05 05:30:00	QQQ	ETF	41.2	41.21	41.19	41.2	1158.0
2009-10-05 06:00:00	QQQ	ETF	41.19	41.22	41.19	41.22	800.0
2009-10-05 06:30:00	QQQ	ETF	41.22	41.22	41.2	41.2	6400.0
2009-10-05 07:00:00	QQQ	ETF	41.2	41.21	41.2	41.2	27348.0
2009-10-05 07:30:00	QQQ	ETF	41.19	41.21	41.17	41.21	85812.0
2009-10-05 08:00:00	QQQ	ETF	41.21	41.21	41.11	41.11	282112.0
2009-10-05 08:30:00	QQQ	ETF	41.12	41.16	41.08	41.09	315001.0
2009-10-05 09:00:00	QQQ	ETF	41.09	41.16	41.08	41.09	1604578.0
2009-10-05 09:30:00	QQQ	ETF	41.08	41.23	40.95	41.08	14120235.0
2009-10-05 10:00:00	QQQ	ETF	41.1	41.24	40.83	41.1	14177751.0
2009-10-05 10:30:00	QQQ	ETF	41.1	41.35	41.08	41.33	6774267.0
2009-10-05 11:00:00	QQQ	ETF	41.34	41.37	41.21	41.23	6493909.0
2009-10-05 11:30:00	QQQ	ETF	41.23	41.28	41.1	41.2	4965211.0
2009-10-05 12:00:00	QQQ	ETF	41.2	41.24	41.15	41.189	2565275.0
2009-10-05 12:30:00	QQQ	ETF	41.18	41.3	41.17	41.25	3564410.0
2009-10-05 13:00:00	QQQ	ETF	41.26	41.3	41.23	41.26	1228906.0
2009-10-05 13:30:00	QQQ	ETF	41.259	41.27	41.19	41.25	2436346.0

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

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