PREVIEW / etf_30min / 2009-10-27

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-27.parquet
  size:    235 KB
  rows:    7,658

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-27 04:00:00	SPY	ETF	107.21	107.21	107.21	107.21	260.0
2009-10-27 05:00:00	SPY	ETF	106.96	106.96	106.96	106.96	2000.0
2009-10-27 05:30:00	SPY	ETF	107.02	107.06	107.02	107.06	1700.0
2009-10-27 06:00:00	SPY	ETF	107.14	107.2	107.06	107.19	4050.0
2009-10-27 06:30:00	SPY	ETF	107.19	107.27	107.19	107.27	11966.0
2009-10-27 07:00:00	SPY	ETF	107.24	107.43	107.24	107.4	80193.0
2009-10-27 07:30:00	SPY	ETF	107.36	107.38	107.1	107.25	136437.0
2009-10-27 08:00:00	SPY	ETF	107.25	107.32	106.97	106.98	882965.0
2009-10-27 08:30:00	SPY	ETF	106.99	107.18	106.95	107.16	693817.0
2009-10-27 09:00:00	SPY	ETF	107.17	107.32	106.94	107.03	1481919.0
2009-10-27 09:30:00	SPY	ETF	107.03	107.34	106.65	106.93	30152522.0
2009-10-27 10:00:00	SPY	ETF	106.93	107.09	106.16	107.08	43898198.0
2009-10-27 10:30:00	SPY	ETF	107.0799	107.39	106.81	107.0705	22234591.0
2009-10-27 11:00:00	SPY	ETF	107.07	107.16	106.76	107.13	11263165.0
2009-10-27 11:30:00	SPY	ETF	107.12	107.24	106.96	107.16	7780019.0
2009-10-27 12:00:00	SPY	ETF	107.16	107.21	106.86	106.9	8213804.0
2009-10-27 12:30:00	SPY	ETF	106.89	107.0	106.68	106.73	9141613.0
2009-10-27 13:00:00	SPY	ETF	106.73	106.87	106.3	106.34	14453112.0
2009-10-27 13:30:00	SPY	ETF	106.34	106.63	106.18	106.45	12812039.0
2009-10-27 14:00:00	SPY	ETF	106.455	106.86	106.25	106.71	12530837.0
2009-10-27 14:30:00	SPY	ETF	106.7	107.01	106.51	106.88	8459529.0
2009-10-27 15:00:00	SPY	ETF	106.88	106.95	106.59	106.71	11078014.0
2009-10-27 15:30:00	SPY	ETF	106.72	106.816	106.3	106.42	30082762.0
2009-10-27 16:00:00	SPY	ETF	106.42	107.15	106.31	106.62	15582748.0
2009-10-27 16:30:00	SPY	ETF	106.61	106.816	106.45	106.64	5448413.0
2009-10-27 17:00:00	SPY	ETF	106.64	106.68	106.6	106.64	183763.0
2009-10-27 17:30:00	SPY	ETF	106.59	106.65	106.45	106.57	2080562.0
2009-10-27 18:00:00	SPY	ETF	106.62	106.77	106.61	106.67	150889.0
2009-10-27 18:30:00	SPY	ETF	106.69	106.816	106.68	106.76	530346.0
2009-10-27 19:00:00	SPY	ETF	106.73	106.75	106.7	106.71	17700.0
2009-10-27 19:30:00	SPY	ETF	106.73	106.75	106.67	106.75	26721.0
2009-10-27 20:00:00	SPY	ETF	106.75	106.75	106.75	106.75	500.0
2009-10-27 04:00:00	QQQ	ETF	43.04	43.05	42.99	42.99	1400.0
2009-10-27 06:00:00	QQQ	ETF	43.02	43.05	43.02	43.05	1500.0
2009-10-27 07:00:00	QQQ	ETF	43.06	43.12	43.06	43.12	8505.0
2009-10-27 07:30:00	QQQ	ETF	43.1	43.1	43.0	43.03	132900.0
2009-10-27 08:00:00	QQQ	ETF	43.05	43.05	42.92	42.92	104203.0
2009-10-27 08:30:00	QQQ	ETF	42.94	43.0	42.93	42.98	98662.0
2009-10-27 09:00:00	QQQ	ETF	42.99	43.05	42.89	42.94	701579.0
2009-10-27 09:30:00	QQQ	ETF	42.94	43.11	42.74	42.74	14929935.0
2009-10-27 10:00:00	QQQ	ETF	42.85	42.85	42.38	42.79	22380501.0
2009-10-27 10:30:00	QQQ	ETF	42.79	43.03	42.72	42.83	12692704.0
2009-10-27 11:00:00	QQQ	ETF	42.83	42.86	42.65	42.77	4383338.0
2009-10-27 11:30:00	QQQ	ETF	42.77	42.78	42.66	42.72	4013818.0
2009-10-27 12:00:00	QQQ	ETF	42.72	42.7399	42.61	42.61	2636167.0
2009-10-27 12:30:00	QQQ	ETF	42.62	42.65	42.51	42.53	4504022.0
2009-10-27 13:00:00	QQQ	ETF	42.53	42.57	42.2175	42.23	12391477.0
2009-10-27 13:30:00	QQQ	ETF	42.22	42.39	42.18	42.3305	7101666.0
2009-10-27 14:00:00	QQQ	ETF	42.34	42.49	42.25	42.44	6278627.0
2009-10-27 14:30:00	QQQ	ETF	42.44	42.56	42.33	42.51	5310799.0

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

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