PREVIEW / etf_30min / 2009-09-14

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-14.parquet
  size:    227 KB
  rows:    7,462

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-09-14 04:00:00	SPY	ETF	103.9	103.9	103.69	103.74	7405.0
2009-09-14 04:30:00	SPY	ETF	103.71	103.71	103.61	103.62	4100.0
2009-09-14 05:00:00	SPY	ETF	103.66	103.66	103.64	103.66	3200.0
2009-09-14 05:30:00	SPY	ETF	103.67	103.77	103.67	103.77	18200.0
2009-09-14 06:00:00	SPY	ETF	103.82	103.93	103.8	103.93	28900.0
2009-09-14 06:30:00	SPY	ETF	103.87	103.9	103.81	103.85	6200.0
2009-09-14 07:00:00	SPY	ETF	103.82	103.85	103.77	103.79	139851.0
2009-09-14 07:30:00	SPY	ETF	103.78	103.91	103.78	103.91	126356.0
2009-09-14 08:00:00	SPY	ETF	103.92	104.02	103.91	103.93	752367.0
2009-09-14 08:30:00	SPY	ETF	103.93	104.0	103.85	103.99	600316.0
2009-09-14 09:00:00	SPY	ETF	103.99	104.0	103.5	103.88	976163.0
2009-09-14 09:30:00	SPY	ETF	103.88	104.43	103.87	104.37	18982864.0
2009-09-14 10:00:00	SPY	ETF	104.36	104.55	104.14	104.46	14005706.0
2009-09-14 10:30:00	SPY	ETF	104.46	104.81	104.43	104.68	15473246.0
2009-09-14 11:00:00	SPY	ETF	104.68	104.9	104.6	104.76	7601357.0
2009-09-14 11:30:00	SPY	ETF	104.77	104.82	104.54	104.58	6056818.0
2009-09-14 12:00:00	SPY	ETF	104.57	104.7351	104.57	104.698	3389170.0
2009-09-14 12:30:00	SPY	ETF	104.7	104.74	104.61	104.7	3492770.0
2009-09-14 13:00:00	SPY	ETF	104.7	104.72	104.56	104.66	6643551.0
2009-09-14 13:30:00	SPY	ETF	104.66	104.89	104.6	104.8316	6467473.0
2009-09-14 14:00:00	SPY	ETF	104.83	105.16	104.76	105.15	7127719.0
2009-09-14 14:30:00	SPY	ETF	105.1591	105.25	103.15	105.18	16185975.0
2009-09-14 15:00:00	SPY	ETF	105.18	105.23	105.08	105.11	12555162.0
2009-09-14 15:30:00	SPY	ETF	105.1	105.46	105.09	105.34	19580167.0
2009-09-14 16:00:00	SPY	ETF	105.33	105.4598	104.19	105.26	4377163.0
2009-09-14 16:30:00	SPY	ETF	105.24	105.25	104.7361	105.21	1133775.0
2009-09-14 17:00:00	SPY	ETF	105.22	105.22	105.15	105.15	3318727.0
2009-09-14 17:30:00	SPY	ETF	105.17	105.21	105.14	105.2	9200.0
2009-09-14 18:00:00	SPY	ETF	105.2	105.34	105.13	105.16	35478.0
2009-09-14 18:30:00	SPY	ETF	105.14	105.34	105.13	105.15	12820.0
2009-09-14 19:00:00	SPY	ETF	105.16	105.18	105.11	105.13	33700.0
2009-09-14 19:30:00	SPY	ETF	105.14	105.16	105.13	105.16	36303.0
2009-09-14 04:00:00	QQQ	ETF	41.11	41.11	41.11	41.11	928.0
2009-09-14 05:00:00	QQQ	ETF	41.1	41.1	41.1	41.1	3000.0
2009-09-14 05:30:00	QQQ	ETF	41.09	41.17	41.09	41.17	37700.0
2009-09-14 06:00:00	QQQ	ETF	41.17	41.2	41.17	41.18	20600.0
2009-09-14 06:30:00	QQQ	ETF	41.17	41.17	41.15	41.15	8500.0
2009-09-14 07:00:00	QQQ	ETF	41.16	41.18	41.1	41.17	47657.0
2009-09-14 07:30:00	QQQ	ETF	41.18	41.21	41.15	41.21	36650.0
2009-09-14 08:00:00	QQQ	ETF	41.2	41.26	41.2	41.2	143173.0
2009-09-14 08:30:00	QQQ	ETF	41.21	41.25	41.19	41.25	97598.0
2009-09-14 09:00:00	QQQ	ETF	41.25	41.25	41.2	41.23	316306.0
2009-09-14 09:30:00	QQQ	ETF	41.23	41.45	41.21	41.44	11896764.0
2009-09-14 10:00:00	QQQ	ETF	41.45	41.51	41.35	41.45	5801265.0
2009-09-14 10:30:00	QQQ	ETF	41.45	41.57	41.44	41.521	5885530.0
2009-09-14 11:00:00	QQQ	ETF	41.524	41.6	41.47	41.56	6295004.0
2009-09-14 11:30:00	QQQ	ETF	41.5501	41.58	41.42	41.44	3195710.0
2009-09-14 12:00:00	QQQ	ETF	41.4499	41.51	41.43	41.4901	1057558.0
2009-09-14 12:30:00	QQQ	ETF	41.5	41.5667	41.47	41.53	2083689.0
2009-09-14 13:00:00	QQQ	ETF	41.53	41.53	41.44	41.49	1899287.0

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

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