PREVIEW / etf_30min / 2010-12-29

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-12-29.parquet
  size:    257 KB
  rows:    8,774

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
2010-12-29 04:00:00	SPY	ETF	126.01	126.04	125.98	125.98	644.0
2010-12-29 05:00:00	SPY	ETF	126.0	126.0	126.0	126.0	10000.0
2010-12-29 05:30:00	SPY	ETF	125.94	126.02	125.94	126.02	2700.0
2010-12-29 06:00:00	SPY	ETF	126.02	126.02	126.02	126.02	500.0
2010-12-29 06:30:00	SPY	ETF	126.0	126.02	125.93	125.93	24100.0
2010-12-29 07:00:00	SPY	ETF	125.93	125.93	125.86	125.92	54460.0
2010-12-29 07:30:00	SPY	ETF	125.9	125.96	125.88	125.88	116229.0
2010-12-29 08:00:00	SPY	ETF	125.89	125.92	125.83	125.9	276920.0
2010-12-29 08:30:00	SPY	ETF	125.91	125.98	125.91	125.97	63646.0
2010-12-29 09:00:00	SPY	ETF	125.97	126.03	125.95	125.99	328564.0
2010-12-29 09:30:00	SPY	ETF	125.98	126.05	125.9	126.01	5636656.0
2010-12-29 10:00:00	SPY	ETF	126.01	126.12	126.01	126.085	4111161.0
2010-12-29 10:30:00	SPY	ETF	126.09	126.1	126.0	126.01	4746084.0
2010-12-29 11:00:00	SPY	ETF	126.01	126.0598	125.96	126.03	3034535.0
2010-12-29 11:30:00	SPY	ETF	126.04	126.07	125.99	126.02	3303947.0
2010-12-29 12:00:00	SPY	ETF	126.0262	126.14	126.0262	126.075	2766749.0
2010-12-29 12:30:00	SPY	ETF	126.075	126.15	126.07	126.12	2839889.0
2010-12-29 13:00:00	SPY	ETF	126.11	126.19	126.11	126.16	2851237.0
2010-12-29 13:30:00	SPY	ETF	126.16	126.18	126.13	126.155	1583956.0
2010-12-29 14:00:00	SPY	ETF	126.16	126.2	126.12	126.14	1710979.0
2010-12-29 14:30:00	SPY	ETF	126.13	126.17	126.1	126.14	1766066.0
2010-12-29 15:00:00	SPY	ETF	126.14	126.19	126.12	126.15	2832084.0
2010-12-29 15:30:00	SPY	ETF	126.15	126.16	125.91	125.93	11132190.0
2010-12-29 16:00:00	SPY	ETF	125.92	126.092	125.86	125.9	6353374.0
2010-12-29 16:30:00	SPY	ETF	125.9	126.0	125.9	125.95	82692.0
2010-12-29 17:00:00	SPY	ETF	125.95	126.0	125.95	125.96	47011.0
2010-12-29 17:30:00	SPY	ETF	125.96	125.96	125.9	125.94	9864.0
2010-12-29 18:00:00	SPY	ETF	125.96	125.99	125.92	125.97	27574.0
2010-12-29 18:30:00	SPY	ETF	125.94	126.0	125.94	125.99	5200.0
2010-12-29 19:00:00	SPY	ETF	125.99	126.0	125.95	125.95	5779.0
2010-12-29 19:30:00	SPY	ETF	125.94	125.97	125.91	125.97	25110.0
2010-12-29 04:00:00	QQQ	ETF	54.76	54.76	54.76	54.76	200.0
2010-12-29 04:30:00	QQQ	ETF	54.75	54.75	54.75	54.75	200.0
2010-12-29 06:00:00	QQQ	ETF	54.8	54.8	54.8	54.8	200.0
2010-12-29 06:30:00	QQQ	ETF	54.81	54.81	54.81	54.81	300.0
2010-12-29 07:00:00	QQQ	ETF	54.79	54.79	54.79	54.79	500.0
2010-12-29 07:30:00	QQQ	ETF	54.8	54.8	54.79	54.79	7800.0
2010-12-29 08:00:00	QQQ	ETF	54.77	54.8	54.75	54.77	28135.0
2010-12-29 08:30:00	QQQ	ETF	54.78	54.81	54.78	54.8	57969.0
2010-12-29 09:00:00	QQQ	ETF	54.8	54.84	54.78	54.83	99227.0
2010-12-29 09:30:00	QQQ	ETF	54.82	54.84	54.73	54.79	2408905.0
2010-12-29 10:00:00	QQQ	ETF	54.79	54.9	54.79	54.881	1976613.0
2010-12-29 10:30:00	QQQ	ETF	54.8899	54.9	54.86	54.86	1403833.0
2010-12-29 11:00:00	QQQ	ETF	54.86	54.88	54.76	54.8	3065226.0
2010-12-29 11:30:00	QQQ	ETF	54.79	54.815	54.78	54.8	1834345.0
2010-12-29 12:00:00	QQQ	ETF	54.8	54.84	54.795	54.825	605691.0
2010-12-29 12:30:00	QQQ	ETF	54.82	54.87	54.82	54.86	590501.0
2010-12-29 13:00:00	QQQ	ETF	54.86	54.89	54.85	54.87	1222437.0
2010-12-29 13:30:00	QQQ	ETF	54.875	54.88	54.83	54.849	950659.0
2010-12-29 14:00:00	QQQ	ETF	54.8475	54.88	54.83	54.85	954711.0

> showing 50 of 8,774 rows — these rows as CSV

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